

-- ----------------------------
-- Table structure for [dbo].[z_png_webform_location_site]
-- ----------------------------
/* DROP TABLE [dbo].[z_png_webform_location_site]
GO
CREATE TABLE [dbo].[z_png_webform_location_site] (
[country_code] nvarchar(20) NOT NULL ,
[country_name] nvarchar(120) NOT NULL ,
[site_code] nvarchar(20) NOT NULL ,
[site_name] nvarchar(120) NOT NULL 
) 

GO
*/
-- ----------------------------
-- Records of z_png_webform_location_site
-- ----------------------------
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'AU', N'Australia & New Zealand', N'5529', N'Acacia Ridge Office');
GO
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'AU', N'Australia & New Zealand', N'7257A', N'Adelaide Training Centre');
GO
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'AU', N'Australia & New Zealand', N'380', N'Berkeley Vale Plant - MFG');
GO
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'AU', N'Australia & New Zealand', N'5481', N'Clayton Sales Office');
GO
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'AU', N'Australia & New Zealand', N'9663', N'Melbourne Office');
GO
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'AU', N'Australia & New Zealand', N'3604', N'P&G Australia P/L Contractors');
GO
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'AU', N'Australia & New Zealand', N'4339', N'Parramatta GO - Australia');
GO
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'AU', N'Australia & New Zealand', N'5794', N'Payneham Customer Business Dev');
GO
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'AU', N'Australia & New Zealand', N'4963', N'Perth Sales Office');
GO
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'AU', N'Australia & New Zealand', N'6112', N'Queensland Sales Office');
GO
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'AU', N'Australia & New Zealand', N'4154', N'Ridleyton Whse');
GO
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'AU', N'Australia & New Zealand', N'5445', N'Rydalmere Plant');
GO
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'AU', N'Australia & New Zealand', N'7261A', N'Subiaco Training Center');
GO
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'AU', N'Australia & New Zealand', N'7260', N'Surrey Hills Training Center');
GO
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'AU', N'Australia & New Zealand', N'8321', N'Sydney GO');
GO
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'AU', N'Australia & New Zealand', N'5528', N'Welshpool Office');
GO
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'AU', N'Australia & New Zealand', N'4966', N'West Lakes SA CBD Office');
GO
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'AU', N'Australia & New Zealand', N'4965', N'Hawthorn - Victoria CBD Office');
GO
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'AU', N'Australia & New Zealand', N'7257B', N'Kent Town Adelde Studio-Wella');
GO
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'AU', N'Australia & New Zealand', N'7258B', N'Brisbane Studio - Wella');
GO
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'AU', N'Australia & New Zealand', N'7261B', N'Subiaco Studio - Wella');
GO
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'AU', N'Australia & New Zealand', N'7526', N'Somersby Plant - Wella');
GO
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'AU', N'Australia & New Zealand', N'7800', N'Scoresby DC');
GO
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'AU', N'Australia & New Zealand', N'8616', N'ACN Pacaus - Scoresby');
GO
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'AU', N'Australia & New Zealand', N'8898', N'Sydney Studio-Wella');
GO
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'AU', N'Australia & New Zealand', N'8971', N'Arimad Plus - W Junction AU');
GO
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'AU', N'Australia & New Zealand', N'7258A', N'Brisbane Training Center');
GO
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'AU', N'Australia & New Zealand', N'1790', N'Online Distribution Center');
GO
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'AU', N'Australia & New Zealand', N'7264', N'Townsville DC');
GO
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'AU', N'Australia & New Zealand', N'4987', N'Auckland Sales Office');
GO
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'AU', N'Australia & New Zealand', N'5535', N'Auckland Office');
GO
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'AU', N'Australia & New Zealand', N'4878', N'Bluff-Palmerston Plant');
GO
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'AU', N'Australia & New Zealand', N'5834', N'Christchurch CBD');
GO
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'AU', N'Australia & New Zealand', N'5149', N'Wellington Sales Office');
GO
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'AU', N'Australia & New Zealand', N'7279', N'Ellerslie SO - Wella');
GO

-------------------------------------------------------------------------------------------------
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'PL', N'Poland', N'7874', N'Lodz Jozefow Plant');
GO
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'PL', N'Poland', N'7875', N'Warsaw GBS');
GO
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'PL', N'Poland', N'8665', N'Warsaw GO Office');
GO
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'PL', N'Poland', N'9043', N'Sochaczew DC');
GO
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'PL', N'Poland', N'2572', N'Aleksandrow Plant');
GO
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'PL', N'Poland', N'4518', N'Targowek Plant');
GO
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'PL', N'Poland', N'7872', N'Lodz Wodna Plant');
GO
/* INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'PL', N'Poland', N'TBC', N'PSC (Planning Center) Warsaw ');
GO */
--------------------------------------------------------
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'CH', N'Switzerland', N'7887', N'Schlieren Office');
GO
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'CH', N'Switzerland', N'4338', N'Geneva Business Centre');
GO
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'CH', N'Switzerland', N'7512', N'Allschwil W/F Main OFC');
GO
------------------------------------------
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'ES', N'Spain', N'4676', N'Madrid General Office');
GO
INSERT INTO [dbo].[z_png_webform_location_site] ([country_code], [country_name], [site_code], [site_name]) VALUES (N'ES', N'Spain', N'4516', N'Mataro Plant');
GO


